
<!DOCTYPE HTML>
<html lang="" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>（一）建表规约 · GitBook</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        
        
        
    
    <link rel="stylesheet" href="../gitbook/style.css">

    
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-prism/prism.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-search/search.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-fontsettings/website.css">
                
            
        

    

    
        
        <link rel="stylesheet" href="../styles/website.css">
        
    

        
    
    
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="索引规约.html" />
    
    

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
<div id="book-search-input" role="search">
    <input type="text" placeholder="Type to search" />
</div>

            
                <nav role="navigation">
                


<ul class="summary">
    
    

    

    
        
        
    
        <li class="chapter " data-level="1.1" data-path="../">
            
                <a href="../">
            
                    
                    前言
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2" >
            
                <span>
            
                    
                    一、编程规约
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.2.1" data-path="../编程规约/命名风格.html">
            
                <a href="../编程规约/命名风格.html">
            
                    
                    （一）命名风格
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.2" data-path="../编程规约/常量定义.html">
            
                <a href="../编程规约/常量定义.html">
            
                    
                    （二）常量定义
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.3" data-path="../编程规约/代码格式.html">
            
                <a href="../编程规约/代码格式.html">
            
                    
                    （三）代码格式
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.4" data-path="../编程规约/OOP规范.html">
            
                <a href="../编程规约/OOP规范.html">
            
                    
                    （四）OOP规范
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.5" data-path="../编程规约/集合处理.html">
            
                <a href="../编程规约/集合处理.html">
            
                    
                    （五）集合处理
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.6" data-path="../编程规约/并发处理.html">
            
                <a href="../编程规约/并发处理.html">
            
                    
                    （六）并发处理
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.7" data-path="../编程规约/控制语句.html">
            
                <a href="../编程规约/控制语句.html">
            
                    
                    （七）控制语句
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.8" data-path="../编程规约/注释规约.html">
            
                <a href="../编程规约/注释规约.html">
            
                    
                    （八）注释规约
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.3" >
            
                <span>
            
                    
                    二、异常日志
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.3.1" data-path="../异常日志/异常处理.html">
            
                <a href="../异常日志/异常处理.html">
            
                    
                    （一）异常处理
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.2" data-path="../异常日志/日志规约.html">
            
                <a href="../异常日志/日志规约.html">
            
                    
                    （二）日志规范
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.3" data-path="../异常日志/其他.html">
            
                <a href="../异常日志/其他.html">
            
                    
                    （三）其他
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.4" data-path="../单元测试.html">
            
                <a href="../单元测试.html">
            
                    
                    三、单元测试
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5" data-path="../安全规约.html">
            
                <a href="../安全规约.html">
            
                    
                    四、安全规约
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6" >
            
                <span>
            
                    
                    五、MySQL数据库
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter active" data-level="1.6.1" data-path="建表规约.html">
            
                <a href="建表规约.html">
            
                    
                    （一）建表规约
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.2" data-path="索引规约.html">
            
                <a href="索引规约.html">
            
                    
                    （二）索引规约
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.3" data-path="SQL语句.html">
            
                <a href="SQL语句.html">
            
                    
                    （三）SQL语句
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.4" data-path="ORM映射.html">
            
                <a href="ORM映射.html">
            
                    
                    （四）ORM映射
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7" >
            
                <span>
            
                    
                    六、工程结构
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1" data-path="../工程结构/应用分层.html">
            
                <a href="../工程结构/应用分层.html">
            
                    
                    （一）应用分层
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.2" data-path="../工程结构/二方库依赖.html">
            
                <a href="../工程结构/二方库依赖.html">
            
                    
                    （二）二方库依赖
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.3" data-path="../工程结构/服务器.html">
            
                <a href="../工程结构/服务器.html">
            
                    
                    （三）服务器
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.8" data-path="../版本历史.html">
            
                <a href="../版本历史.html">
            
                    
                    附1：版本历史 
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.9" data-path="../本手册专有名词.html">
            
                <a href="../本手册专有名词.html">
            
                    
                    附2：本手册专有名词 
            
                </a>
            

            
        </li>
    

    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            Published with GitBook
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    

<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href=".." >（一）建表规约</a>
    </h1>
</div>




                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
<div id="book-search-results">
    <div class="search-noresults">
    
                                <section class="normal markdown-section">
                                
                                <h1 id="&#x4E94;&#x3001;mysql&#x6570;&#x636E;&#x5E93;">&#x4E94;&#x3001;MySQL&#x6570;&#x636E;&#x5E93;</h1>
<h2 id="&#x4E00;-&#x5EFA;&#x8868;&#x89C4;&#x7EA6;">(&#x4E00;) &#x5EFA;&#x8868;&#x89C4;&#x7EA6;</h2>
<ol>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x8868;&#x8FBE;&#x662F;&#x4E0E;&#x5426;&#x6982;&#x5FF5;&#x7684;&#x5B57;&#x6BB5;&#xFF0C;&#x5FC5;&#x987B;&#x4F7F;&#x7528;is_xxx&#x7684;&#x65B9;&#x5F0F;&#x547D;&#x540D;&#xFF0C;&#x6570;&#x636E;&#x7C7B;&#x578B;&#x662F;unsigned tinyint&#xFF08; 1&#x8868;&#x793A;&#x662F;&#xFF0C;0&#x8868;&#x793A;&#x5426;&#xFF09;&#x3002; 
<br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;&#x4EFB;&#x4F55;&#x5B57;&#x6BB5;&#x5982;&#x679C;&#x4E3A;&#x975E;&#x8D1F;&#x6570;&#xFF0C;&#x5FC5;&#x987B;&#x662F;<code>unsigned</code>&#x3002; 
<br><span style="color:green">&#x6B63;&#x4F8B;</span>&#xFF1A;&#x8868;&#x8FBE;&#x903B;&#x8F91;&#x5220;&#x9664;&#x7684;&#x5B57;&#x6BB5;&#x540D;<code>is_deleted</code>&#xFF0C;1&#x8868;&#x793A;&#x5220;&#x9664;&#xFF0C;0&#x8868;&#x793A;&#x672A;&#x5220;&#x9664;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x8868;&#x540D;&#x3001;&#x5B57;&#x6BB5;&#x540D;&#x5FC5;&#x987B;&#x4F7F;&#x7528;&#x5C0F;&#x5199;&#x5B57;&#x6BCD;&#x6216;&#x6570;&#x5B57;&#xFF0C;&#x7981;&#x6B62;&#x51FA;&#x73B0;&#x6570;&#x5B57;&#x5F00;&#x5934;&#xFF0C;&#x7981;&#x6B62;&#x4E24;&#x4E2A;&#x4E0B;&#x5212;&#x7EBF;&#x4E2D;&#x95F4;&#x53EA;&#x51FA;&#x73B0;&#x6570;&#x5B57;&#x3002;&#x6570;&#x636E;&#x5E93;&#x5B57;&#x6BB5;&#x540D;&#x7684;&#x4FEE;&#x6539;&#x4EE3;&#x4EF7;&#x5F88;&#x5927;&#xFF0C;&#x56E0;&#x4E3A;&#x65E0;&#x6CD5;&#x8FDB;&#x884C;&#x9884;&#x53D1;&#x5E03;&#xFF0C;&#x6240;&#x4EE5;&#x5B57;&#x6BB5;&#x540D;&#x79F0;&#x9700;&#x8981;&#x614E;&#x91CD;&#x8003;&#x8651;&#x3002; <br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;MySQL&#x5728;Windows&#x4E0B;&#x4E0D;&#x533A;&#x5206;&#x5927;&#x5C0F;&#x5199;&#xFF0C;&#x4F46;&#x5728;Linux&#x4E0B;&#x9ED8;&#x8BA4;&#x662F;&#x533A;&#x5206;&#x5927;&#x5C0F;&#x5199;&#x3002;&#x56E0;&#x6B64;&#xFF0C;&#x6570;&#x636E;&#x5E93;&#x540D;&#x3001;&#x8868;&#x540D;&#x3001;&#x5B57;&#x6BB5;&#x540D;&#xFF0C;&#x90FD;&#x4E0D;&#x5141;&#x8BB8;&#x51FA;&#x73B0;&#x4EFB;&#x4F55;&#x5927;&#x5199;&#x5B57;&#x6BCD;&#xFF0C;&#x907F;&#x514D;&#x8282;&#x5916;&#x751F;&#x679D;&#x3002; <br><span style="color:green">&#x6B63;&#x4F8B;</span>&#xFF1A;aliyun_admin&#xFF0C;rdc_config&#xFF0C;level3_name <br><span style="color:red">&#x53CD;&#x4F8B;</span>&#xFF1A;AliyunAdmin&#xFF0C;rdcConfig&#xFF0C;level_3_name </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x8868;&#x540D;&#x4E0D;&#x4F7F;&#x7528;&#x590D;&#x6570;&#x540D;&#x8BCD;&#x3002; 
<br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;&#x8868;&#x540D;&#x5E94;&#x8BE5;&#x4EC5;&#x4EC5;&#x8868;&#x793A;&#x8868;&#x91CC;&#x9762;&#x7684;&#x5B9E;&#x4F53;&#x5185;&#x5BB9;&#xFF0C;&#x4E0D;&#x5E94;&#x8BE5;&#x8868;&#x793A;&#x5B9E;&#x4F53;&#x6570;&#x91CF;&#xFF0C;&#x5BF9;&#x5E94;&#x4E8E;DO&#x7C7B;&#x540D;&#x4E5F;&#x662F;&#x5355;&#x6570;&#x5F62;&#x5F0F;&#xFF0C;&#x7B26;&#x5408;&#x8868;&#x8FBE;&#x4E60;&#x60EF;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x7981;&#x7528;&#x4FDD;&#x7559;&#x5B57;&#xFF0C;&#x5982;<code>desc</code>&#x3001;<code>range</code>&#x3001;<code>match</code>&#x3001;<code>delayed</code>&#x7B49;&#xFF0C;&#x8BF7;&#x53C2;&#x8003;MySQL&#x5B98;&#x65B9;&#x4FDD;&#x7559;&#x5B57;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x4E3B;&#x952E;&#x7D22;&#x5F15;&#x540D;&#x4E3A;pk<em>&#x5B57;&#x6BB5;&#x540D;&#xFF1B;&#x552F;&#x4E00;&#x7D22;&#x5F15;&#x540D;&#x4E3A;uk</em>&#x5B57;&#x6BB5;&#x540D;&#xFF1B;&#x666E;&#x901A;&#x7D22;&#x5F15;&#x540D;&#x5219;&#x4E3A;idx<em>&#x5B57;&#x6BB5;&#x540D;&#x3002; 
<br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;pk</em> &#x5373;primary key&#xFF1B;uk<em> &#x5373; unique key&#xFF1B;idx</em> &#x5373;index&#x7684;&#x7B80;&#x79F0;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x5C0F;&#x6570;&#x7C7B;&#x578B;&#x4E3A;decimal&#xFF0C;&#x7981;&#x6B62;&#x4F7F;&#x7528;float&#x548C;double&#x3002; 
<br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;float&#x548C;double&#x5728;&#x5B58;&#x50A8;&#x7684;&#x65F6;&#x5019;&#xFF0C;&#x5B58;&#x5728;&#x7CBE;&#x5EA6;&#x635F;&#x5931;&#x7684;&#x95EE;&#x9898;&#xFF0C;&#x5F88;&#x53EF;&#x80FD;&#x5728;&#x503C;&#x7684;&#x6BD4;&#x8F83;&#x65F6;&#xFF0C;&#x5F97;&#x5230;&#x4E0D;&#x6B63;&#x786E;&#x7684;&#x7ED3;&#x679C;&#x3002;&#x5982;&#x679C;&#x5B58;&#x50A8;&#x7684;&#x6570;&#x636E;&#x8303;&#x56F4;&#x8D85;&#x8FC7;decimal&#x7684;&#x8303;&#x56F4;&#xFF0C;&#x5EFA;&#x8BAE;&#x5C06;&#x6570;&#x636E;&#x62C6;&#x6210;&#x6574;&#x6570;&#x548C;&#x5C0F;&#x6570;&#x5206;&#x5F00;&#x5B58;&#x50A8;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x5982;&#x679C;&#x5B58;&#x50A8;&#x7684;&#x5B57;&#x7B26;&#x4E32;&#x957F;&#x5EA6;&#x51E0;&#x4E4E;&#x76F8;&#x7B49;&#xFF0C;&#x4F7F;&#x7528;char&#x5B9A;&#x957F;&#x5B57;&#x7B26;&#x4E32;&#x7C7B;&#x578B;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;varchar&#x662F;&#x53EF;&#x53D8;&#x957F;&#x5B57;&#x7B26;&#x4E32;&#xFF0C;&#x4E0D;&#x9884;&#x5148;&#x5206;&#x914D;&#x5B58;&#x50A8;&#x7A7A;&#x95F4;&#xFF0C;&#x957F;&#x5EA6;&#x4E0D;&#x8981;&#x8D85;&#x8FC7;5000&#xFF0C;&#x5982;&#x679C;&#x5B58;&#x50A8;&#x957F;&#x5EA6;&#x5927;&#x4E8E;&#x6B64;&#x503C;&#xFF0C;&#x5B9A;&#x4E49;&#x5B57;&#x6BB5;&#x7C7B;&#x578B;&#x4E3A;text&#xFF0C;&#x72EC;&#x7ACB;&#x51FA;&#x6765;&#x4E00;&#x5F20;&#x8868;&#xFF0C;&#x7528;&#x4E3B;&#x952E;&#x6765;&#x5BF9;&#x5E94;&#xFF0C;&#x907F;&#x514D;&#x5F71;&#x54CD;&#x5176;&#x5B83;&#x5B57;&#x6BB5;&#x7D22;&#x5F15;&#x6548;&#x7387;&#x3002; </li>
<li>&#x3010;&#x5F3A;&#x5236;&#x3011;&#x8868;&#x5FC5;&#x5907;&#x4E09;&#x5B57;&#x6BB5;&#xFF1A;id, gmt_create, gmt_modified&#x3002; 
<br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;&#x5176;&#x4E2D;id&#x5FC5;&#x4E3A;&#x4E3B;&#x952E;&#xFF0C;&#x7C7B;&#x578B;&#x4E3A;unsigned bigint&#x3001;&#x5355;&#x8868;&#x65F6;&#x81EA;&#x589E;&#x3001;&#x6B65;&#x957F;&#x4E3A;1&#x3002;gmt_create, gmt_modified&#x7684;&#x7C7B;&#x578B;&#x5747;&#x4E3A;datetime&#x7C7B;&#x578B;&#xFF0C;&#x524D;&#x8005;&#x73B0;&#x5728;&#x65F6;&#x8868;&#x793A;&#x4E3B;&#x52A8;&#x521B;&#x5EFA;&#xFF0C;&#x540E;&#x8005;&#x8FC7;&#x53BB;&#x5206;&#x8BCD;&#x8868;&#x793A;&#x88AB;&#x52A8;&#x66F4;&#x65B0;&#x3002; </li>
<li>&#x3010;&#x63A8;&#x8350;&#x3011;&#x8868;&#x7684;&#x547D;&#x540D;&#x6700;&#x597D;&#x662F;&#x52A0;&#x4E0A;&#x201C;&#x4E1A;&#x52A1;&#x540D;&#x79F0;_&#x8868;&#x7684;&#x4F5C;&#x7528;&#x201D;&#x3002; 
<br><span style="color:green">&#x6B63;&#x4F8B;</span>&#xFF1A;alipay_task / force_project / trade_config </li>
<li>&#x3010;&#x63A8;&#x8350;&#x3011;&#x5E93;&#x540D;&#x4E0E;&#x5E94;&#x7528;&#x540D;&#x79F0;&#x5C3D;&#x91CF;&#x4E00;&#x81F4;&#x3002; </li>
<li>&#x3010;&#x63A8;&#x8350;&#x3011;&#x5982;&#x679C;&#x4FEE;&#x6539;&#x5B57;&#x6BB5;&#x542B;&#x4E49;&#x6216;&#x5BF9;&#x5B57;&#x6BB5;&#x8868;&#x793A;&#x7684;&#x72B6;&#x6001;&#x8FFD;&#x52A0;&#x65F6;&#xFF0C;&#x9700;&#x8981;&#x53CA;&#x65F6;&#x66F4;&#x65B0;&#x5B57;&#x6BB5;&#x6CE8;&#x91CA;&#x3002; </li>
<li>&#x3010;&#x63A8;&#x8350;&#x3011;&#x5B57;&#x6BB5;&#x5141;&#x8BB8;&#x9002;&#x5F53;&#x5197;&#x4F59;&#xFF0C;&#x4EE5;&#x63D0;&#x9AD8;&#x67E5;&#x8BE2;&#x6027;&#x80FD;&#xFF0C;&#x4F46;&#x5FC5;&#x987B;&#x8003;&#x8651;&#x6570;&#x636E;&#x4E00;&#x81F4;&#x3002;&#x5197;&#x4F59;&#x5B57;&#x6BB5;&#x5E94;&#x9075;&#x5FAA;&#xFF1A;<br>1&#xFF09;&#x4E0D;&#x662F;&#x9891;&#x7E41;&#x4FEE;&#x6539;&#x7684;&#x5B57;&#x6BB5;&#x3002;<br>2&#xFF09;&#x4E0D;&#x662F;varchar&#x8D85;&#x957F;&#x5B57;&#x6BB5;&#xFF0C;&#x66F4;&#x4E0D;&#x80FD;&#x662F;text&#x5B57;&#x6BB5;&#x3002;
<br><span style="color:green">&#x6B63;&#x4F8B;</span>&#xFF1A;&#x5546;&#x54C1;&#x7C7B;&#x76EE;&#x540D;&#x79F0;&#x4F7F;&#x7528;&#x9891;&#x7387;&#x9AD8;&#xFF0C;&#x5B57;&#x6BB5;&#x957F;&#x5EA6;&#x77ED;&#xFF0C;&#x540D;&#x79F0;&#x57FA;&#x672C;&#x4E00;&#x6210;&#x4E0D;&#x53D8;&#xFF0C;&#x53EF;&#x5728;&#x76F8;&#x5173;&#x8054;&#x7684;&#x8868;&#x4E2D;&#x5197;&#x4F59;&#x5B58;&#x50A8;&#x7C7B;&#x76EE;&#x540D;&#x79F0;&#xFF0C;&#x907F;&#x514D;&#x5173;&#x8054;&#x67E5;&#x8BE2;&#x3002; </li>
<li>&#x3010;&#x63A8;&#x8350;&#x3011;&#x5355;&#x8868;&#x884C;&#x6570;&#x8D85;&#x8FC7;500&#x4E07;&#x884C;&#x6216;&#x8005;&#x5355;&#x8868;&#x5BB9;&#x91CF;&#x8D85;&#x8FC7;2GB&#xFF0C;&#x624D;&#x63A8;&#x8350;&#x8FDB;&#x884C;&#x5206;&#x5E93;&#x5206;&#x8868;&#x3002; <br><span style="color:orange">&#x8BF4;&#x660E;</span>&#xFF1A;&#x5982;&#x679C;&#x9884;&#x8BA1;&#x4E09;&#x5E74;&#x540E;&#x7684;&#x6570;&#x636E;&#x91CF;&#x6839;&#x672C;&#x8FBE;&#x4E0D;&#x5230;&#x8FD9;&#x4E2A;&#x7EA7;&#x522B;&#xFF0C;&#x8BF7;&#x4E0D;&#x8981;&#x5728;&#x521B;&#x5EFA;&#x8868;&#x65F6;&#x5C31;&#x5206;&#x5E93;&#x5206;&#x8868;&#x3002; </li>
<li>&#x3010;&#x53C2;&#x8003;&#x3011;&#x5408;&#x9002;&#x7684;&#x5B57;&#x7B26;&#x5B58;&#x50A8;&#x957F;&#x5EA6;&#xFF0C;&#x4E0D;&#x4F46;&#x8282;&#x7EA6;&#x6570;&#x636E;&#x5E93;&#x8868;&#x7A7A;&#x95F4;&#x3001;&#x8282;&#x7EA6;&#x7D22;&#x5F15;&#x5B58;&#x50A8;&#xFF0C;&#x66F4;&#x91CD;&#x8981;&#x7684;&#x662F;&#x63D0;&#x5347;&#x68C0;&#x7D22;&#x901F;&#x5EA6;&#x3002; <br><span style="color:green">&#x6B63;&#x4F8B;</span>&#xFF1A;&#x5982;&#x4E0B;&#x8868;&#xFF0C;&#x5176;&#x4E2D;&#x65E0;&#x7B26;&#x53F7;&#x503C;&#x53EF;&#x4EE5;&#x907F;&#x514D;&#x8BEF;&#x5B58;&#x8D1F;&#x6570;&#xFF0C;&#x4E14;&#x6269;&#x5927;&#x4E86;&#x8868;&#x793A;&#x8303;&#x56F4;&#x3002; </li>
</ol>
<table>
<thead>
<tr>
<th>&#x5BF9;&#x8C61;</th>
<th style="text-align:left">&#x5E74;&#x9F84;&#x533A;&#x95F4;</th>
<th style="text-align:left">&#x7C7B;&#x578B;</th>
<th style="text-align:left">&#x5B57;&#x8282;</th>
</tr>
</thead>
<tbody>
<tr>
<td>&#x4EBA;</td>
<td style="text-align:left">150&#x5C81;&#x4E4B;&#x5185;</td>
<td style="text-align:left">unsigned tinyint</td>
<td style="text-align:left">1</td>
</tr>
<tr>
<td>&#x9F9F;</td>
<td style="text-align:left">&#x6570;&#x767E;&#x5C81;</td>
<td style="text-align:left">unsigned smallint</td>
<td style="text-align:left">2</td>
</tr>
<tr>
<td>&#x6050;&#x9F99;&#x5316;&#x77F3;</td>
<td style="text-align:left">&#x6570;&#x5343;&#x4E07;&#x5C81;</td>
<td style="text-align:left">unsigned int</td>
<td style="text-align:left">4</td>
</tr>
<tr>
<td>&#x592A;&#x9633;</td>
<td style="text-align:left">&#x7EA6;50&#x4EBF;&#x5E74;</td>
<td style="text-align:left">unsigned bigint</td>
<td style="text-align:left">8</td>
</tr>
</tbody>
</table>

                                
                                </section>
                            
    </div>
    <div class="search-results">
        <div class="has-results">
            
            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>
            
        </div>
        <div class="no-results">
            
            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
            
        </div>
    </div>
</div>

                        </div>
                    </div>
                
            </div>

            
                
                
                <a href="索引规约.html" class="navigation navigation-next navigation-unique" aria-label="Next page: （二）索引规约">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
        
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"（一）建表规约","level":"1.6.1","depth":2,"next":{"title":"（二）索引规约","level":"1.6.2","depth":2,"path":"MySQL数据库/索引规约.md","ref":"MySQL数据库/索引规约.md","articles":[]},"previous":{"title":"五、MySQL数据库","level":"1.6","depth":1,"ref":"","articles":[{"title":"（一）建表规约","level":"1.6.1","depth":2,"path":"MySQL数据库/建表规约.md","ref":"MySQL数据库/建表规约.md","articles":[]},{"title":"（二）索引规约","level":"1.6.2","depth":2,"path":"MySQL数据库/索引规约.md","ref":"MySQL数据库/索引规约.md","articles":[]},{"title":"（三）SQL语句","level":"1.6.3","depth":2,"path":"MySQL数据库/SQL语句.md","ref":"MySQL数据库/SQL语句.md","articles":[]},{"title":"（四）ORM映射","level":"1.6.4","depth":2,"path":"MySQL数据库/ORM映射.md","ref":"MySQL数据库/ORM映射.md","articles":[]}]},"dir":"ltr"},"config":{"gitbook":"*","theme":"default","variables":{},"plugins":["book-summary-scroll-position-saver","github","prism","-sharing","-highlight"],"pluginsConfig":{"github":{"url":"https://github.com/alibaba/p3c"},"book-summary-scroll-position-saver":{},"prism":{},"search":{},"lunr":{"maxIndexSize":1000000,"ignoreSpecialCharacters":false},"fontsettings":{"theme":"white","family":"sans","size":2},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"styles":{"website":"styles/website.css"}},"file":{"path":"MySQL数据库/建表规约.md","mtime":"2018-01-13T07:52:52.580Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2018-01-15T14:41:43.583Z"},"basePath":"..","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="../gitbook/gitbook.js"></script>
    <script src="../gitbook/theme.js"></script>
    
        
        <script src="../gitbook/gitbook-plugin-book-summary-scroll-position-saver/book-summary-scroll-position-saver.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-github/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-search/search-engine.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-search/search.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-lunr/lunr.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-lunr/search-lunr.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    

    </body>
</html>

